Supplier workspaces and enquiries

Open: Purchase Ledger > Purchase Enquiries > Accounts.

• Select a supplier account and see the details, contacts, factor houses, credit details, aged balances, analysis codes, turnover, attachments and memos.

• Open a related workspace with the content already filtered. For example, if you want to view the transactions for a specific account, select the account (using the check box) and choose Actions > Supplier Current Transaction Enquiry. The Supplier Current Transaction Enquiry workspace opens with the list of transactions filtered for the selected account.

  Note: This option is not available if you have more than one row selected.

• Add a memo to an account. Select the account (using the check box) and choose Actions > Add Memo.
• Desktop only - Complete related tasks from the list of Actions, such as amending an account, or entering an invoice or purchase order for a selected account.
• Sort and filter the list of accounts. Use the filter options to see information such as supplier accounts by analysis code, or by credit limit, or by accounts on hold.
• Search for a specific account. For example, use the toolbar filter to find an account by reference or name.
• Print a list of the accounts that you are interested in.
• Export the list of accounts that you are interested in to an Excel spreadsheet.
• Run related reports.

Open: Purchase Ledger > Purchase Enquiries > Current Transactions.

Use this to see a detailed breakdown of each current transaction held on your supplier accounts. You can use this to establish whether it has been fully paid, part paid or remains outstanding.

You can:

• Select a transaction and see the transaction details, allocation details, associated bank transactions, associated purchase document lines, memos and view nominal, tax and project details.

• Open a related workspace with the content already filtered. For example, if you want to view the account for a specific transaction, select the transaction (using the check box) and choose Actions > Supplier Account Enquiry. The Supplier Account Enquiry workspace opens with the list of accounts filtered for the selected transaction.

  Note: This option is not available if you have more than one item selected.

• View and add a query flag to a transaction.

  You can assign or remove a query flag on a transaction. Placing a query prevents further actions on a transaction until you remove the query. This is different from applying an On Hold flag to the whole account.

  To add a query flag, select the transaction and choose Actions > Query Code.

  Note: Sage 200 automatically assigns the following query flag: U for unauthorised transaction. Other than this letter you can apply any letter to the transaction that is meaningful to you.

• Add a memo to a transaction. Select the transaction (using the check box) and choose Actions > Add Memo.

• Desktop only - Complete related tasks from the list of Actions, such as amend an allocation.
• Sort and filter the list of transactions. Use the filter options to see information such as outstanding transactions, transactions by due date, transactions for a specific supplier, or transactions by settlement discount due date and so forth.
• Search for a specific transaction. For example, use the toolbar filter to find a transaction by reference, date, or value.
• Print the details of transactions you are interested in.
• Export the details of transactions you are interested in to an Excel spreadsheet.
• Run related reports.

Open: Purchase Ledger > Period End > Payment Processing > Suggested Payments.

Use this to check the payment amounts for each supplier and the transactions that make up that amount.

You can:

• Select a supplier and see the total cheque value and invoices and credit notes that are included in the cheque value.
• Complete related tasks from the list of Actions, such as process the payments for the selected supplier.

• Open a related workspace with the content already filtered. For example, if you want to view the account for a specific payment, select the payment (using the check box) and choose Actions > Supplier Account Enquiry. The Supplier Account Enquiry workspace opens with the list of accounts filtered for the selected transaction.

  Note: This option is not available if you have more than one item selected.

• Desktop only - Complete related tasks from the list of Actions, such as generate or amend suggested payments.
• Sort and filter the list of suppliers. Use the filter options to see information such as all suppliers with suggested payment above a certain value, or suppliers with payments above the maximum cheque value.
• Search for a specific supplier or transaction. For example, use the toolbar filter to find a supplier by account reference or cheque value or to find a transaction by reference or due date.
• Print the list of suppliers or transactions that you are interested in.
• Export the list of suppliers or transactions that you are interested in to an Excel spreadsheet.
• Run related reports.

Open: Purchase Ledger > Period End > Payment Processing > Payment Control Enquiry.

Use this to view and make enquiries about the suppliers that you owe money to. Only those suppliers with overdue balances are displayed.

You can:

• Select a supplier and see all outstanding transactions for that supplier as well as details of the supplier account such as contacts, turnover, memos, disputed transactions and terms.
• Select an overdue transaction for a selected supplier and see all details for that transaction such as associated nominal transactions, allocation history or memos.
• Sort and filter the list of suppliers. Use the filter options to see information such as a list of suppliers with balances over their credit limit or a list of suppliers with balances that are over a certain value.
• Sort and filter the list of transactions for a selected supplier. Use the filter options to see information such as a list of transactions by due date, or by transaction type.
• Desktop only - Complete related tasks from the list of Actions, such as amend an allocation.
• Search for a specific supplier or a specific transaction for a supplier. For example, use the toolbar filter to find an account by name or reference.

• Print the details of supplier accounts or transactions that you are interested in.

• Export the details of the supplier accounts or transactions that you are interested in to an Excel spreadsheet.
• Run related reports.

Open: Purchase Ledger > Purchase Enquiries > Archived Transaction Enquiry.

Use this to see a detailed breakdown of the archived transaction held on your supplier accounts.

On Premise deployments only -Transactions are archived when you run the Period End Routines > Account Maintenance option, using the options selected on the Purchase Ledger Settings | Supplier Defaults tab.

You can:

• Select a transaction and see the transaction details, associated bank transactions, and view nominal, tax and project details.

• Open a related workspace with the content already filtered. For example, if you want to view the account for a specific transaction, select the transaction (using the check box) and choose Actions > Supplier Account Enquiry. The Supplier Account Enquiry workspace opens with the list of accounts filtered for the selected transaction.

  Note: This option is not available if you have more than one item selected.

• Sort and filter the list of transactions. Use the filter options to see information such as outstanding transactions, transactions by due date, transactions for a specific supplier, by settlements discount due date and so on.
• Search for a specific transaction. For example, use the toolbar filter to find a transaction by reference, date, or value.
• Print the details of transactions you are interested in.
• Export the details of transactions you are interested in to an Excel spreadsheet.

Open: Workspaces drop-down list.

• Select Purchase Ledger > Supplier List.

Use this to see a list of all your suppliers.

You can:

• Open a related workspace with the content already filtered. For example, if you want to view the transactions for a specific account, select the account (using the check box) and choose Actions > Supplier Current Transaction Enquiry. The Supplier Current Transaction Enquiry workspace opens with the list of transactions filtered for the selected account.

  Note: This option is not available if you have more than one row selected.

• Add a memo to an account. Select the account (using the check box) and choose Actions > Add Memo.
• Desktop only - Complete related tasks from the list of Actions, such as amending an account, or entering an invoice or purchase order for a selected account.
• Sort and filter the list of accounts. Use the filter options to see information such as supplier accounts by analysis code, or by credit limit, or by accounts on hold.
• Search for a specific account. For example, use the toolbar filter to find an account by reference or name.
• Print a list of the accounts that you are interested in.
• Export the list of accounts that you are interested in to an Excel spreadsheet.

You can use the Creditors Reconciliation Enquiry to help you ensure your financial statements are correct. Before you can run this enquiry you must have set up the default nominal account for the enquiry in the Nominal Ledger.

For more information, see Creditors reconciliation enquiry.